package com.shuqing.dao;

import com.shuqing.domain.User;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

/**
 * @program: ShuqingLibrary
 * @ClassName UserMapper
 * @description:
 * @author: Ats
 * @create: 2025-03-31 10:47
 * @Version 1.0
 */
public interface UserMapper {


 @Select("select * from user where user_email=#{email} and user_password=#{password} and user_status !='1'")
@Results(id = "userMap", value = {
        @Result(id = true,column = "user_id",property = "id"),
        @Result(column = "user_name",property = "name"),
        @Result(column = "user_password",property = "password"),
        @Result(column = "user_email",property = "email"),
        @Result(column = "user_role",property = "role"),
        @Result(column = "user_status",property = "status")
})
 public User login(User user);
}

